# -*- coding: UTF-8 -*-
__author__ = 'EBOY'

import sqlite3

conn = sqlite3.connect('db.db')
try:
    c = conn.cursor()
    c.execute('''CREATE TABLE stocks (date text, trans text, symbol text, qty real, price real)''')
    c.execute("INSERT INTO stocks VALUES ('2006-01-01', 'BUY', 'RHAT', 100, 35.14)")
    conn.commit()
    c.close()

finally:
    conn.close()

